Building a Data Integration Team by Jarrett Goldfedder

Author:Jarrett Goldfedder
Language: eng
Format: epub
ISBN: 9781484256534
Publisher: Apress

If we’re ready then, let’s start by discussing the first of our tools.

Jitterbit

Web site: www.jitterbit.com/

Review: Jitterbit was one of the first cloud-based ETL tools I used, and the experience was a positive one: using its freemium Salesforce Data Loader, I was able to build some excellent, scheduled integrations that took place in the cloud. Objects (the Salesforce equivalent of database tables) could be moved in hours, not days, using a sophisticated GUI (see Figure 5-5). We were clear we wanted to use this tool as our database backup system, and it served the need well. We were a bit stymied when the integrations became more complicated, but as time and technology have advanced, Jitterbit is offering more capabilities for API auto-creation and API management, and its future looks promising for its base of small and midsize companies. If you’re just starting with ETL and the design is not too complicated, definitely explore the trial for this, as the company offers both on-premise and cloud-based solutions.

Pros: Simple to configure and deploy with relatively little downtime. Can handle a multitude of data connectors, including SAS, Salesforce, database, and web services. Technical support is very helpful and willing to answer most questions.

Cons: As integrations become more complex, so does the setup. Documentation at the time was sparse, and we did have multiple questions about security for cloud-based offerings.

Figure 5-5Jitterbit API Transformation

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.